Select the entire PivotTable list
Note You can't display the title bar if the PivotTable list is not bound to a data source.
Select a row, column, or filter field
Note Selecting a row or column field also selects all of the items of data in the field.
Note Selecting an item selects all of the data for that item.
Select a subtotal or grand total
Note Selecting a subtotal or grand total also selects all of the data for the subtotal or grand total.
Select the title bar or a drop area
Select a custom property of a row or column field
Note If the selected field does not have any custom properties, the Item properties list will be empty.
You can set the caption, number format, and display location settings for the selected property. The formats you select affect only the selected property.
Note Font and text style settings that you apply to a custom property affect all custom properties in the PivotTable list, but only when they are displayed in the report. The formatting is ignored when the custom property is displayed in the ScreenTip.
Specify font and style settings
To make the text bold, click Bold .
To make the text italic, click Italic .
To underline the text, click Underline .
To change the text color, click the arrow next to Font Color , and then click the color you want.
To change the font, click a different font in the font list.
To change the font size, select a size from the list next to the font list.
Note The fonts and font sizes available in the lists are determined by the fonts you have installed on your computer.
Change the number format of a field, total, or item property of a row or column field
Note The number format of a field does not affect the number format of other row, column, filter, or total fields. The number format of an item property does not affect other item properties.
Notes